﻿/*
*Criacao : Mauricio --- Data : --/--/----
*Revisao : Mauricio --- Data : 10/10/2011
*Tarefas : 
*OK
*/CREATE TABLE [dbo].[TBAutomovel] (
    [automovelID]   INT             IDENTITY (1, 1) NOT NULL,
    [modeloID]      INT             NOT NULL,
    [garagemID]     INT             NULL,
    [anoFabricacao] SMALLINT        NOT NULL,
    [anoModelo]     SMALLINT        NOT NULL,
    [preco]         NUMERIC (10, 2) NOT NULL,
    [blindado]      BIT             NOT NULL,
    [quilometragem] INT             NOT NULL,
    [cambio]        NVARCHAR (30)   NOT NULL,
    [portas]        TINYINT         NOT NULL,
    [cor]           NVARCHAR (50)   NOT NULL,
    [combustivel]   NVARCHAR (50)   NOT NULL,
    [observacoes]   NVARCHAR (MAX)  NOT NULL,
    [pasta]         NVARCHAR (100)  NOT NULL,
	[ativo]			BIT				NOT NULL,
	[venda]			BIT				NOT NULL,
	[vitrine]		BIT				NULL
);

